www.gusucode.com > ROCKOA PHP协同办公OA办公系统 v2.0PHP源码程序 > ROCKOA PHP协同办公OA办公系统 v2.0/rockoa_v2.0/rockoa_v2.0/webrock/humanres/supple/ext_supple_totalscript.js
var monye = js.now('Y-m'); var panel = { xtype:'rockgrid',tablename:'supplea',formtitle:'办公用品统计',exceltitle:'办公用品统计', url:publicstore(mode, dir),highsearchbool:false,searchtools:true, keywhere:'and status in(1,3,4)', defaultwhere:"and `optdt` like '"+monye+"%'", tbarcenter:[{ xtype:'rockdate',format:'month',width:100,value:monye }], execlparams:{excelchuli:'status',status_arr:'待确认,已发放,不通过驳回,入库,异常入库'}, outsearch:function(){ var s= "and `optdt` like '"+this.down('rockdate').getValue()+"%'"; return s; }, columns:[{ xtype: 'rownumberer', width: 40 },{ text:'部门',dataIndex:'deptname',width:200 },{ text:'姓名',dataIndex:'name',width:100 },{ text:'物品名称',dataIndex:'aname',width:200,search:true,searchtpl:"aid in(select id from [Q]supple where name ?0 ?1)" },{ text:'申请数',dataIndex:'total',width:100,search:true },{ text:'说明',dataIndex:'explain',search:true,autowidth:true },{ text:'状态',dataIndex:'status',width:150,boxdata:[['red','待发放'],['green','已发放'],['blue','驳回'],['#ff6600','入库'],['#800000','异常入库']],search:true,renderer:renderbox,atype:'select',store:js.arraystr('0|待确认,1|已发放,2|不通过驳回,3|入库,4|异常入库') },{ text:'操作时间',dataIndex:'optdt',width:160 }] }; return { panel:panel };